Release 10.1A: OpenEdge Development:
Progress Dynamics Basic Development

Site numbers

The framework assigns a value to this field for every table with a standard database trigger. The value is derived from two (or potentially more) database sequences, whose values are generated by a trigger or by adding your own code to a trigger, are combined to form the high-order and low-order portions of the whole-number portion of the field’s value. The values of two sequences are combined because a single integer might not be sufficient over time to store all possible values for all database records.

The decimal portion of the value is meant to be a unique site number to identify a particular user organization. The decimal portion is set to the reverse of the site number so that trailing zeros in a site number do not lose their significance. For example, site number 710 yields object ID keys ending in .017, and site number 7100 yields key values ending in .0017. This is necessary because .710 and .7100 have the same decimal value. A site number allocation service exists on the Progress Web site (http://www.progress.com/dynamics/sitenumber). The service allows application developers to reserve a range of site numbers for all their customers. Thus, every Progress Dynamics database anywhere in the world can have a unique site number.

Note: See Chapter 4, "Preparing to Build Application Objects," for more information on the site number application.